SetConditionalFormatting(Int32,Int32,Int32,Int32,Boolean,IConditionalFormattingRule[]) Method
In This Topic
Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
Syntax
'Declaration
Public Overloads Sub SetConditionalFormatting( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As Boolean, _
ByVal ParamArray () As IConditionalFormattingRule _
)
'Usage
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim combinable As Boolean
Dim rules() As IConditionalFormattingRule
instance.SetConditionalFormatting(row, column, rowCount, columnCount, combinable, rules)
public void SetConditionalFormatting(
int ,
int column,
int ,
int columnCount,
bool ,
params IConditionalFormattingRule[]
)
Parameters
- row
- Starting row index
- column
- Starting column index
- rowCount
- Number of rows
- columnCount
- Number of columns
- combinable
- Rule(s) can be merged into an existing conditional format if they affect the same cell range(s).
- rules
- The specified rules to apply for a specified range of cells
Example
This example uses the SetConditionalFormatting method.
See Also